﻿CREATE TABLE [dbo].[InvoiceDetail_log] (
    [InvoiceNo]  VARCHAR (30)    NOT NULL,
    [LineNo]     VARCHAR (3)     NOT NULL,
    [ProductNo]  VARCHAR (10)    NOT NULL,
    [Qty]        NUMERIC (10, 2) NULL,
    [Price]      NUMERIC (10, 2) NULL,
    [Amount]     NUMERIC (15, 2) NULL,
    [TaxRate]    NUMERIC (10, 4) NULL,
    [TaxAmount]  NUMERIC (15, 2) NULL,
    [Remark]     VARCHAR (60)    NULL,
    [RecordID]   INT             NOT NULL,
    [UserID]     VARCHAR (60)    NOT NULL,
    [ModifyTime] DATETIME        NOT NULL,
    [Action]     CHAR (1)        NOT NULL
);

